Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	2987
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	291.7 KiB
Average record size in memory	100.0 B

Variable types

Numeric	12

Alerts

`gross_revenue` is highly overall correlated with `qty_invoices` and 3 other fields	High correlation
`qty_invoices` is highly overall correlated with `gross_revenue` and 3 other fields	High correlation
`qty_items_purchased` is highly overall correlated with `gross_revenue` and 3 other fields	High correlation
`products_variety` is highly overall correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly overall correlated with `avg_variety_basket`	High correlation
`recency_days` is highly overall correlated with `qty_invoices`	High correlation
`avg_recency_days` is highly overall correlated with `frequency_days`	High correlation
`frequency_days` is highly overall correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly overall correlated with `gross_revenue` and 1 other fields	High correlation
`avg_variety_basket` is highly overall correlated with `products_variety` and 1 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 24.66292639)	Skewed
`total_return` is highly skewed (γ1 = 26.93587857)	Skewed
`customer_id` has unique values	Unique
`recency_days` has 33 (1.1%) zeros	Zeros
`total_return` has 1500 (50.2%) zeros	Zeros

Reproduction

Analysis started	2023-01-26 14:18:37.559380
Analysis finished	2023-01-26 14:19:00.773584
Duration	23.21 seconds
Software version	pandas-profiling vdev
Download configuration	config.json

customer_id
Real number (ℝ)

Distinct	2987
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15268.629

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	35.0 KiB

Quantile statistics

Minimum	12347
5-th percentile	12613.6
Q1	13791.5
median	15220
Q3	16770.5
95-th percentile	17964.7
Maximum	18287
Range	5940
Interquartile range (IQR)	2979

Descriptive statistics

Standard deviation	1721.4222
Coefficient of variation (CV)	0.11274242
Kurtosis	-1.2080253
Mean	15268.629
Median Absolute Deviation (MAD)	1491
Skewness	0.030183419
Sum	45607394
Variance	2963294.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
13223	1	< 0.1%
12670	1	< 0.1%
17588	1	< 0.1%
14759	1	< 0.1%
16185	1	< 0.1%
13505	1	< 0.1%
13389	1	< 0.1%
17631	1	< 0.1%
17061	1	< 0.1%
Other values (2977)	2977	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12363	1	< 0.1%
12364	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18269	1	< 0.1%

gross_revenue
Real number (ℝ)

Distinct	2972
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2677.8825

Minimum	5.9
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	5.9
5-th percentile	227.507
Q1	566.59
median	1079.34
Q3	2296.855
95-th percentile	7123.119
Maximum	279138.02
Range	279132.12
Interquartile range (IQR)	1730.265

Descriptive statistics

Standard deviation	10083.327
Coefficient of variation (CV)	3.7654107
Kurtosis	401.66922
Mean	2677.8825
Median Absolute Deviation (MAD)	667.74
Skewness	17.717157
Sum	7998835
Variance	1.0167349 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
731.9	2	0.1%
745.06	2	0.1%
1025.44	2	0.1%
178.96	2	0.1%
598.2	2	0.1%
533.33	2	0.1%
379.65	2	0.1%
2053.02	2	0.1%
331	2	0.1%
889.93	2	0.1%
Other values (2962)	2967	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5.9	1	< 0.1%
6.2	1	< 0.1%
13.3	1	< 0.1%
36.56	1	< 0.1%
45	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
63	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
136275.72	1	< 0.1%
124564.53	1	< 0.1%
116729.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%
65039.62	1	< 0.1%

qty_invoices
Real number (ℝ)

Distinct	57
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.6916639

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	205
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.8227128
Coefficient of variation (CV)	1.5501114
Kurtosis	191.0355
Mean	5.6916639
Median Absolute Deviation (MAD)	2
Skewness	10.765303
Sum	17001
Variance	77.840262
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	788	26.4%
3	498	16.7%
4	394	13.2%
5	236	7.9%
1	206	6.9%
6	173	5.8%
7	139	4.7%
8	98	3.3%
9	69	2.3%
10	54	1.8%
Other values (47)	332	11.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	206	6.9%
2	788	26.4%
3	498	16.7%
4	394	13.2%
5	236	7.9%
6	173	5.8%
7	139	4.7%
8	98	3.3%
9	69	2.3%
10	54	1.8%

Value	Count	Frequency (%)
206	1	< 0.1%
198	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	1	< 0.1%
90	1	< 0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%

qty_items_purchased
Real number (ℝ)

Distinct	1678
Distinct (%)	56.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1574.2133

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	2
5-th percentile	101
Q1	294.5
median	628
Q3	1395.5
95-th percentile	4395.2
Maximum	196844
Range	196842
Interquartile range (IQR)	1101

Descriptive statistics

Standard deviation	5687.5781
Coefficient of variation (CV)	3.6129654
Kurtosis	519.9407
Mean	1574.2133
Median Absolute Deviation (MAD)	413
Skewness	18.793868
Sum	4702175
Variance	32348544
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
88	9	0.3%
150	9	0.3%
134	8	0.3%
272	8	0.3%
260	8	0.3%
84	8	0.3%
288	8	0.3%
114	8	0.3%
246	8	0.3%
Other values (1668)	2902	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	3	0.1%
12	2	0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%
25	1	< 0.1%
26	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80179	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57872	1	< 0.1%
50255	1	< 0.1%

products_variety
Real number (ℝ)

Distinct	339
Distinct (%)	11.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	79.019083

Minimum	1
Maximum	1785
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	1
5-th percentile	7
Q1	25
median	52
Q3	100
95-th percentile	233
Maximum	1785
Range	1784
Interquartile range (IQR)	75

Descriptive statistics

Standard deviation	96.634915
Coefficient of variation (CV)	1.2229314
Kurtosis	82.657155
Mean	79.019083
Median Absolute Deviation (MAD)	33
Skewness	6.3987239
Sum	236030
Variance	9338.3067
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24	44	1.5%
18	42	1.4%
37	40	1.3%
28	40	1.3%
25	37	1.2%
15	37	1.2%
11	37	1.2%
26	37	1.2%
23	36	1.2%
30	36	1.2%
Other values (329)	2601	87.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	26	0.9%
2	16	0.5%
3	20	0.7%
4	20	0.7%
5	35	1.2%
6	22	0.7%
7	26	0.9%
8	30	1.0%
9	32	1.1%
10	27	0.9%

Value	Count	Frequency (%)
1785	1	< 0.1%
1766	1	< 0.1%
1322	1	< 0.1%
1118	1	< 0.1%
884	1	< 0.1%
816	1	< 0.1%
717	1	< 0.1%
713	1	< 0.1%
699	1	< 0.1%
636	1	< 0.1%

avg_ticket
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	2985
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.191821

Minimum	2.1505882
Maximum	4453.43
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	2.1505882
5-th percentile	4.9309583
Q1	13.111564
median	17.931321
Q3	24.84247
95-th percentile	90.11325
Maximum	4453.43
Range	4451.2794
Interquartile range (IQR)	11.730905

Descriptive statistics

Standard deviation	120.28843
Coefficient of variation (CV)	3.6240381
Kurtosis	788.44422
Mean	33.191821
Median Absolute Deviation (MAD)	5.9524292
Skewness	24.662926
Sum	99143.97
Variance	14469.305
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.162	2	0.1%
14.47833333	2	0.1%
32.64	1	< 0.1%
31.5408046	1	< 0.1%
53.92173913	1	< 0.1%
15.94088235	1	< 0.1%
17.07774194	1	< 0.1%
17.22099526	1	< 0.1%
15.64627451	1	< 0.1%
13.54692308	1	< 0.1%
Other values (2975)	2975	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
4453.43	1	< 0.1%
3202.92	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
931.5	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%

recency_days
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	272
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.818212

Minimum	0
Maximum	373
Zeros	33
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	11
median	32
Q3	84
95-th percentile	242
Maximum	373
Range	373
Interquartile range (IQR)	73

Descriptive statistics

Standard deviation	78.0885
Coefficient of variation (CV)	1.2047309
Kurtosis	2.7156163
Mean	64.818212
Median Absolute Deviation (MAD)	26
Skewness	1.7838576
Sum	193612
Variance	6097.8139
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.3%
4	87	2.9%
3	85	2.8%
2	84	2.8%
8	76	2.5%
10	67	2.2%
7	66	2.2%
9	66	2.2%
17	64	2.1%
15	55	1.8%
Other values (262)	2238	74.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	33	1.1%
1	99	3.3%
2	84	2.8%
3	85	2.8%
4	87	2.9%
5	43	1.4%
7	66	2.2%
8	76	2.5%
9	66	2.2%
10	67	2.2%

Value	Count	Frequency (%)
373	2	0.1%
372	3	0.1%
371	1	< 0.1%
368	1	< 0.1%
366	4	0.1%
365	3	0.1%
364	1	< 0.1%
360	2	0.1%
359	1	< 0.1%
358	4	0.1%

avg_recency_days
Real number (ℝ)

Distinct	1254
Distinct (%)	42.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	66.852708

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	1
5-th percentile	7.4329798
Q1	25.267857
median	47.666667
Q3	84.875
95-th percentile	200.7
Maximum	366
Range	365
Interquartile range (IQR)	59.607143

Descriptive statistics

Standard deviation	63.423688
Coefficient of variation (CV)	0.94870784
Kurtosis	4.9626506
Mean	66.852708
Median Absolute Deviation (MAD)	26.121212
Skewness	2.0767769
Sum	199689.04
Variance	4022.5642
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	24	0.8%
4	23	0.8%
70	22	0.7%
7	20	0.7%
1	19	0.6%
46	18	0.6%
21	18	0.6%
35	18	0.6%
11	18	0.6%
49	18	0.6%
Other values (1244)	2789	93.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	19	0.6%
1.5	1	< 0.1%
2	14	0.5%
2.5	1	< 0.1%
2.565517241	1	< 0.1%
3	15	0.5%
3.271929825	1	< 0.1%
3.321428571	1	< 0.1%
3.5	2	0.1%
4	23	0.8%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
362	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency_days
Real number (ℝ)

Distinct	1223
Distinct (%)	40.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44.64533

Minimum	0.058823529
Maximum	183.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	0.058823529
5-th percentile	1
Q1	19.972222
median	38.444444
Q3	61
95-th percentile	112.33333
Maximum	183.5
Range	183.44118
Interquartile range (IQR)	41.027778

Descriptive statistics

Standard deviation	34.161602
Coefficient of variation (CV)	0.7651775
Kurtosis	1.9050532
Mean	44.64533
Median Absolute Deviation (MAD)	20.444444
Skewness	1.2373278
Sum	133355.6
Variance	1167.015
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	214	7.2%
16	18	0.6%
36	17	0.6%
42	16	0.5%
29	15	0.5%
11	15	0.5%
12	15	0.5%
34	14	0.5%
47	13	0.4%
39	13	0.4%
Other values (1213)	2637	88.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.05882352941	1	< 0.1%
0.3333333333	1	< 0.1%
0.5	7	0.2%
0.875	1	< 0.1%
1	214	7.2%
1.333333333	1	< 0.1%
1.5	3	0.1%
1.815533981	1	< 0.1%
1.883838384	1	< 0.1%
2	3	0.1%

Value	Count	Frequency (%)
183.5	1	< 0.1%
183	1	< 0.1%
182.5	1	< 0.1%
182	1	< 0.1%
179	2	0.1%
178.5	1	< 0.1%
178	2	0.1%
176.5	1	< 0.1%
176	2	0.1%
175.5	3	0.1%

total_return
Real number (ℝ)

SKEWED ZEROS

Distinct	172
Distinct (%)	5.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.773686

Minimum	-0
Maximum	9014
Zeros	1500
Zeros (%)	50.2%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	-0
5-th percentile	0
Q1	-0
median	0
Q3	6
95-th percentile	60.7
Maximum	9014
Range	9014
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	227.91924
Coefficient of variation (CV)	9.2000538
Kurtosis	918.13916
Mean	24.773686
Median Absolute Deviation (MAD)	0
Skewness	26.935879
Sum	73999
Variance	51947.181
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0	1500	50.2%
1	295	9.9%
3	169	5.7%
6	93	3.1%
2	88	2.9%
4	71	2.4%
5	43	1.4%
12	43	1.4%
8	40	1.3%
7	38	1.3%
Other values (162)	607	20.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0	1500	50.2%
1	295	9.9%
2	88	2.9%
3	169	5.7%
4	71	2.4%
5	43	1.4%
6	93	3.1%
7	38	1.3%
8	40	1.3%
9	36	1.2%

Value	Count	Frequency (%)
9014	1	< 0.1%
4824	1	< 0.1%
4027	1	< 0.1%
2302	2	0.1%
1776	1	< 0.1%
1608	1	< 0.1%
1589	1	< 0.1%
1515	1	< 0.1%
1278	1	< 0.1%
1242	1	< 0.1%

avg_basket_size
Real number (ℝ)

Distinct	1985
Distinct (%)	66.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	236.74411

Minimum	1
Maximum	6009.3333
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	1
5-th percentile	44.066667
Q1	103.275
median	172.25
Q3	282
95-th percentile	599.64
Maximum	6009.3333
Range	6008.3333
Interquartile range (IQR)	178.725

Descriptive statistics

Standard deviation	284.14695
Coefficient of variation (CV)	1.2002281
Kurtosis	101.78121
Mean	236.74411
Median Absolute Deviation (MAD)	83.25
Skewness	7.6532698
Sum	707154.66
Variance	80739.487
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
114	11	0.4%
73	9	0.3%
86	9	0.3%
136	9	0.3%
82	9	0.3%
60	9	0.3%
140	8	0.3%
163	8	0.3%
75	8	0.3%
Other values (1975)	2896	97.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	2	0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
6009.333333	1	< 0.1%
4282	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2801	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%
2082.225806	1	< 0.1%

avg_variety_basket
Real number (ℝ)

Distinct	911
Distinct (%)	30.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.542001

Minimum	0.2
Maximum	259
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	0.2
5-th percentile	2
Q1	7.7298387
median	13.625
Q3	22.2
95-th percentile	46
Maximum	259
Range	258.8
Interquartile range (IQR)	14.470161

Descriptive statistics

Standard deviation	15.48703
Coefficient of variation (CV)	0.88285424
Kurtosis	28.897321
Mean	17.542001
Median Absolute Deviation (MAD)	6.625
Skewness	3.4059968
Sum	52397.956
Variance	239.84808
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	43	1.4%
9	42	1.4%
16	40	1.3%
8	39	1.3%
14	39	1.3%
17	38	1.3%
5	38	1.3%
7	38	1.3%
11	37	1.2%
15	35	1.2%
Other values (901)	2598	87.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	6	0.2%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.4%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
259	1	< 0.1%
177	1	< 0.1%
148	1	< 0.1%
127	1	< 0.1%
105	1	< 0.1%
104	1	< 0.1%
101	1	< 0.1%
98	1	< 0.1%
95.5	1	< 0.1%
94.33333333	1	< 0.1%

Auto

Heatmap
Table

	customer_id	gross_revenue	qty_invoices	qty_items_purchased	products_variety	avg_ticket	recency_days	avg_recency_days	frequency_days	total_return	avg_basket_size	avg_variety_basket
customer_id	1.000	-0.076	0.027	-0.070	0.006	-0.130	0.001	0.023	0.002	-0.063	-0.125	-0.020
gross_revenue	-0.076	1.000	0.772	0.925	0.667	0.246	-0.417	-0.250	-0.080	0.363	0.572	0.105
qty_invoices	0.027	0.772	1.000	0.718	0.585	0.061	-0.507	-0.251	-0.060	0.290	0.099	-0.183
qty_items_purchased	-0.070	0.925	0.718	1.000	0.664	0.169	-0.409	-0.231	-0.071	0.338	0.727	0.146
products_variety	0.006	0.667	0.585	0.664	1.000	-0.452	-0.384	-0.109	0.012	0.196	0.386	0.636
avg_ticket	-0.130	0.246	0.061	0.169	-0.452	1.000	0.048	-0.128	-0.088	0.197	0.189	-0.615
recency_days	0.001	-0.417	-0.507	-0.409	-0.384	0.048	1.000	0.107	-0.027	-0.120	-0.095	0.016
avg_recency_days	0.023	-0.250	-0.251	-0.231	-0.109	-0.128	0.107	1.000	0.871	-0.388	-0.087	0.129
frequency_days	0.002	-0.080	-0.060	-0.071	0.012	-0.088	-0.027	0.871	1.000	-0.224	-0.029	0.116
total_return	-0.063	0.363	0.290	0.338	0.196	0.197	-0.120	-0.388	-0.224	1.000	0.207	-0.063
avg_basket_size	-0.125	0.572	0.099	0.727	0.386	0.189	-0.095	-0.087	-0.029	0.207	1.000	0.404
avg_variety_basket	-0.020	0.105	-0.183	0.146	0.636	-0.615	0.016	0.129	0.116	-0.063	0.404	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	gross_revenue	qty_invoices	qty_items_purchased	products_variety	avg_ticket	recency_days	avg_recency_days	frequency_days	total_return	avg_basket_size	avg_variety_basket
0	17850	5391.21	34.0	1733.0	21.0	18.152222	372.0	35.500000	0.058824	21.0	50.970588	0.617647
1	13047	3232.59	9.0	1390.0	105.0	18.904035	56.0	26.307692	35.333333	6.0	154.444444	11.666667
2	12583	6705.38	15.0	5028.0	114.0	28.902500	2.0	21.823529	24.800000	50.0	335.200000	7.600000
3	13748	948.25	5.0	439.0	24.0	33.866071	95.0	92.666667	55.800000	-0.0	87.800000	4.800000
4	15100	876.00	3.0	80.0	1.0	292.000000	333.0	8.600000	13.666667	22.0	26.666667	0.333333
5	15291	4623.30	14.0	2102.0	61.0	45.326471	25.0	21.750000	24.928571	27.0	150.142857	4.357143
6	14688	5630.87	21.0	3621.0	148.0	17.219786	7.0	18.300000	17.476190	281.0	172.428571	7.047619
7	17809	5411.91	12.0	2057.0	46.0	88.719836	16.0	32.454545	29.833333	41.0	171.416667	3.833333
8	15311	60767.90	91.0	38194.0	567.0	25.543464	0.0	4.144444	4.109890	231.0	419.714286	6.230769
9	16098	2005.63	7.0	613.0	34.0	29.934776	87.0	47.666667	41.000000	-0.0	87.571429	4.857143

	customer_id	gross_revenue	qty_invoices	qty_items_purchased	products_variety	avg_ticket	recency_days	avg_recency_days	frequency_days	total_return	avg_basket_size	avg_variety_basket
5611	17727	1060.25	1.0	645.0	66.0	16.064394	15.0	6.0	1.000000	6.0	645.000000	66.000000
5621	17232	421.52	2.0	203.0	30.0	11.708889	2.0	12.0	6.500000	-0.0	101.500000	15.000000
5622	17468	137.00	2.0	116.0	5.0	27.400000	10.0	4.0	2.500000	-0.0	58.000000	2.500000
5633	13596	697.04	2.0	406.0	133.0	4.199036	5.0	7.0	4.000000	-0.0	203.000000	66.500000
5639	14893	1237.85	2.0	799.0	72.0	16.956849	9.0	2.0	1.500000	-0.0	399.500000	36.000000
5643	12479	473.20	1.0	382.0	30.0	15.773333	11.0	4.0	1.000000	34.0	382.000000	30.000000
5664	14126	706.13	3.0	508.0	14.0	47.075333	7.0	3.0	1.333333	50.0	169.333333	4.666667
5670	13521	1092.39	3.0	733.0	312.0	2.511241	1.0	4.5	3.333333	-0.0	244.333333	104.000000
5680	15060	301.84	4.0	262.0	80.0	2.515333	8.0	1.0	0.500000	-0.0	65.500000	20.000000
5699	12558	269.96	1.0	196.0	11.0	24.541818	7.0	6.0	1.000000	102.0	196.000000	11.000000

Overview

Variables

Interactions

Correlations

Missing values

Sample